USE [texchange_db]
GO

/****** Object:  StoredProcedure [dbo].[SP_InsUser]    Script Date: 05/29/2011 19:49:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE proc [dbo].[SP_InsUser] 
  @Name nvarchar(100),
  @username nvarchar(50),
  @password nvarchar(50),
  @isActive bit,
  @userType nvarchar(10),
  @company_id bigint
as
	BEGIN
		SET NOCOUNT ON

		INSERT INTO Users (Name,username,[password],isActive,userType,company_id) 
		VALUES(@Name,@username,@password,@isActive,@userType,@company_id)
		SELECT NEWID = @@Identity
	END




GO


